Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 7719 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 8.6 MiB |
| Average record size in memory | 1.1 KiB |
Variable types
| Numeric | 6 |
|---|---|
| Text | 8 |
| DateTime | 2 |
| Categorical | 8 |
Category is highly overall correlated with Sub-Category | High correlation |
Market is highly overall correlated with Region | High correlation |
Region is highly overall correlated with Market | High correlation |
Row ID is highly overall correlated with Shipping Cost | High correlation |
Sales is highly overall correlated with Shipping Cost | High correlation |
Shipping Cost is highly overall correlated with Row ID and 1 other fields | High correlation |
Sub-Category is highly overall correlated with Category | High correlation |
Row ID has unique values | Unique |
Discount has 4504 (58.3%) zeros | Zeros |
Profit has 101 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-23 12:04:54.756750 |
|---|---|
| Analysis finished | 2025-01-23 12:05:01.331035 |
| Duration | 6.57 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
Row ID
Real number (ℝ)
High correlation  Unique 
| Distinct | 7719 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5588.1985 |
| Minimum | 1 |
|---|---|
| Maximum | 9999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1384.8 |
| Q1 | 3424.5 |
| median | 5651 |
| Q3 | 7826.5 |
| 95-th percentile | 9565.1 |
| Maximum | 9999 |
| Range | 9998 |
| Interquartile range (IQR) | 4402 |
Descriptive statistics
| Standard deviation | 2610.2139 |
|---|---|
| Coefficient of variation (CV) | 0.46709399 |
| Kurtosis | -1.0934312 |
| Mean | 5588.1985 |
| Median Absolute Deviation (MAD) | 2202 |
| Skewness | -0.10128571 |
| Sum | 43135304 |
| Variance | 6813216.6 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 7155 | 1 | < 0.1% |
| 7116 | 1 | < 0.1% |
| 7114 | 1 | < 0.1% |
| 7111 | 1 | < 0.1% |
| 7110 | 1 | < 0.1% |
| 7108 | 1 | < 0.1% |
| 7107 | 1 | < 0.1% |
| 7106 | 1 | < 0.1% |
| 7105 | 1 | < 0.1% |
| Other values (7709) | 7709 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 17 | 1 | |
| 22 | 1 | |
| 29 | 1 | |
| 33 | 1 | |
| 35 | 1 | |
| 37 | 1 |
| Value | Count | Frequency (%) |
| 9999 | 1 | |
| 9998 | 1 | |
| 9997 | 1 | |
| 9996 | 1 | |
| 9995 | 1 | |
| 9994 | 1 | |
| 9992 | 1 | |
| 9991 | 1 | |
| 9990 | 1 | |
| 9989 | 1 |
Order ID
Text
| Distinct | 5985 |
|---|---|
| Distinct (%) | 77.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 604.2 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 23.137842 |
| Min length | 20 |
Unique
| Unique | 4777 ? |
|---|---|
| Unique (%) | 61.9% |
Sample
| 1st row | CA-2014-AB10015140-41954 |
|---|---|
| 2nd row | CA-2014-AB10015140-41954 |
| 3rd row | CA-2012-AB10015140-40974 |
| 4th row | CA-2012-AB10015140-40974 |
| 5th row | CA-2012-AB10015140-40958 |
| Value | Count | Frequency (%) |
| ca-2015-ac10615140-42250 | 11 | 0.1% |
| ca-2014-ag10270140-41896 | 9 | 0.1% |
| ca-2013-bt11680140-41464 | 9 | 0.1% |
| ca-2012-aj10795140-41271 | 7 | 0.1% |
| ca-2014-ai10855140-41954 | 7 | 0.1% |
| ca-2015-am10705140-42207 | 7 | 0.1% |
| ca-2013-bs11665140-41595 | 7 | 0.1% |
| ca-2015-as10225140-42265 | 7 | 0.1% |
| ca-2012-bh11710140-41068 | 7 | 0.1% |
| ca-2015-bs11800140-42104 | 6 | 0.1% |
| Other values (5975) | 7642 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 28019 | |
| - | 23157 | |
| 0 | 19382 | |
| 2 | 19269 | |
| 4 | 16725 | |
| 5 | 12063 | 6.8% |
| 3 | 7389 | 4.1% |
| 8 | 6066 | 3.4% |
| 9 | 5634 | 3.2% |
| 7 | 5282 | 3.0% |
| Other values (30) | 35615 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 178601 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28019 | |
| - | 23157 | |
| 0 | 19382 | |
| 2 | 19269 | |
| 4 | 16725 | |
| 5 | 12063 | 6.8% |
| 3 | 7389 | 4.1% |
| 8 | 6066 | 3.4% |
| 9 | 5634 | 3.2% |
| 7 | 5282 | 3.0% |
| Other values (30) | 35615 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 178601 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28019 | |
| - | 23157 | |
| 0 | 19382 | |
| 2 | 19269 | |
| 4 | 16725 | |
| 5 | 12063 | 6.8% |
| 3 | 7389 | 4.1% |
| 8 | 6066 | 3.4% |
| 9 | 5634 | 3.2% |
| 7 | 5282 | 3.0% |
| Other values (30) | 35615 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 178601 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28019 | |
| - | 23157 | |
| 0 | 19382 | |
| 2 | 19269 | |
| 4 | 16725 | |
| 5 | 12063 | 6.8% |
| 3 | 7389 | 4.1% |
| 8 | 6066 | 3.4% |
| 9 | 5634 | 3.2% |
| 7 | 5282 | 3.0% |
| Other values (30) | 35615 |
Order Date
Date
| Distinct | 1290 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.4 KiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2015-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Ship Date
Date
| Distinct | 1384 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 60.4 KiB |
| Minimum | 2012-01-03 00:00:00 |
|---|---|
| Maximum | 2016-01-06 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 524.6 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.573002 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | First Class |
|---|---|
| 2nd row | First Class |
| 3rd row | First Class |
| 4th row | First Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 4004 | |
| Second Class | 1690 | |
| First Class | 1505 | 19.5% |
| Same Day | 520 | 6.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 7199 | |
| standard | 4004 | |
| second | 1690 | 10.9% |
| first | 1505 | 9.7% |
| same | 520 | 3.4% |
| day | 520 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 16247 | |
| s | 15903 | |
| d | 9698 | |
| 7719 | ||
| l | 7199 | |
| C | 7199 | |
| S | 6214 | 6.4% |
| n | 5694 | 5.9% |
| r | 5509 | 5.7% |
| t | 5509 | 5.7% |
| Other values (8) | 10160 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 97051 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 16247 | |
| s | 15903 | |
| d | 9698 | |
| 7719 | ||
| l | 7199 | |
| C | 7199 | |
| S | 6214 | 6.4% |
| n | 5694 | 5.9% |
| r | 5509 | 5.7% |
| t | 5509 | 5.7% |
| Other values (8) | 10160 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 97051 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 16247 | |
| s | 15903 | |
| d | 9698 | |
| 7719 | ||
| l | 7199 | |
| C | 7199 | |
| S | 6214 | 6.4% |
| n | 5694 | 5.9% |
| r | 5509 | 5.7% |
| t | 5509 | 5.7% |
| Other values (8) | 10160 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 97051 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 16247 | |
| s | 15903 | |
| d | 9698 | |
| 7719 | ||
| l | 7199 | |
| C | 7199 | |
| S | 6214 | 6.4% |
| n | 5694 | 5.9% |
| r | 5509 | 5.7% |
| t | 5509 | 5.7% |
| Other values (8) | 10160 |
Customer ID
Text
| Distinct | 5009 |
|---|---|
| Distinct (%) | 64.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 507.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.336183 |
| Min length | 7 |
Unique
| Unique | 3520 ? |
|---|---|
| Unique (%) | 45.6% |
Sample
| 1st row | AB-100151402 |
|---|---|
| 2nd row | AB-100151402 |
| 3rd row | AB-100151404 |
| 4th row | AB-100151404 |
| 5th row | AB-100151402 |
| Value | Count | Frequency (%) |
| ap-109151404 | 22 | 0.3% |
| bm-116501402 | 16 | 0.2% |
| ai-108551404 | 15 | 0.2% |
| ac-106151406 | 13 | 0.2% |
| bt-116801406 | 13 | 0.2% |
| bd-113201404 | 13 | 0.2% |
| aj-107951404 | 12 | 0.2% |
| bc-111251404 | 11 | 0.1% |
| bp-110951404 | 11 | 0.1% |
| as-100901406 | 10 | 0.1% |
| Other values (4999) | 7583 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 12937 | |
| 0 | 9166 | |
| - | 7719 | |
| 5 | 7241 | 9.1% |
| 4 | 5414 | 6.8% |
| 2 | 4884 | 6.1% |
| 8 | 4089 | 5.1% |
| 7 | 3331 | 4.2% |
| 3 | 3250 | 4.1% |
| 9 | 3165 | 4.0% |
| Other values (30) | 18589 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 79785 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12937 | |
| 0 | 9166 | |
| - | 7719 | |
| 5 | 7241 | 9.1% |
| 4 | 5414 | 6.8% |
| 2 | 4884 | 6.1% |
| 8 | 4089 | 5.1% |
| 7 | 3331 | 4.2% |
| 3 | 3250 | 4.1% |
| 9 | 3165 | 4.0% |
| Other values (30) | 18589 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 79785 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12937 | |
| 0 | 9166 | |
| - | 7719 | |
| 5 | 7241 | 9.1% |
| 4 | 5414 | 6.8% |
| 2 | 4884 | 6.1% |
| 8 | 4089 | 5.1% |
| 7 | 3331 | 4.2% |
| 3 | 3250 | 4.1% |
| 9 | 3165 | 4.0% |
| Other values (30) | 18589 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 79785 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 12937 | |
| 0 | 9166 | |
| - | 7719 | |
| 5 | 7241 | 9.1% |
| 4 | 5414 | 6.8% |
| 2 | 4884 | 6.1% |
| 8 | 4089 | 5.1% |
| 7 | 3331 | 4.2% |
| 3 | 3250 | 4.1% |
| 9 | 3165 | 4.0% |
| Other values (30) | 18589 |
Customer Name
Text
| Distinct | 792 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 531.0 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.953621 |
| Min length | 7 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Aaron Bergman |
|---|---|
| 2nd row | Aaron Bergman |
| 3rd row | Aaron Bergman |
| 4th row | Aaron Bergman |
| 5th row | Aaron Bergman |
| Value | Count | Frequency (%) |
| brian | 126 | 0.8% |
| alan | 116 | 0.7% |
| barry | 116 | 0.7% |
| anthony | 102 | 0.7% |
| bill | 98 | 0.6% |
| anna | 89 | 0.6% |
| adam | 82 | 0.5% |
| arthur | 79 | 0.5% |
| ben | 77 | 0.5% |
| paul | 76 | 0.5% |
| Other values (899) | 14519 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 9119 | 9.1% |
| e | 8990 | 9.0% |
| n | 8209 | 8.2% |
| 7761 | 7.8% | |
| r | 7468 | 7.5% |
| i | 5671 | 5.7% |
| l | 5296 | 5.3% |
| o | 4687 | 4.7% |
| t | 4119 | 4.1% |
| s | 3496 | 3.5% |
| Other values (47) | 35173 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 99989 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 9119 | 9.1% |
| e | 8990 | 9.0% |
| n | 8209 | 8.2% |
| 7761 | 7.8% | |
| r | 7468 | 7.5% |
| i | 5671 | 5.7% |
| l | 5296 | 5.3% |
| o | 4687 | 4.7% |
| t | 4119 | 4.1% |
| s | 3496 | 3.5% |
| Other values (47) | 35173 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 99989 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 9119 | 9.1% |
| e | 8990 | 9.0% |
| n | 8209 | 8.2% |
| 7761 | 7.8% | |
| r | 7468 | 7.5% |
| i | 5671 | 5.7% |
| l | 5296 | 5.3% |
| o | 4687 | 4.7% |
| t | 4119 | 4.1% |
| s | 3496 | 3.5% |
| Other values (47) | 35173 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 99989 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 9119 | 9.1% |
| e | 8990 | 9.0% |
| n | 8209 | 8.2% |
| 7761 | 7.8% | |
| r | 7468 | 7.5% |
| i | 5671 | 5.7% |
| l | 5296 | 5.3% |
| o | 4687 | 4.7% |
| t | 4119 | 4.1% |
| s | 3496 | 3.5% |
| Other values (47) | 35173 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 496.4 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8324913 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Consumer |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 4005 | |
| Corporate | 2358 | |
| Home Office | 1356 | 17.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 4005 | |
| corporate | 2358 | |
| home | 1356 | 14.9% |
| office | 1356 | 14.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 10077 | |
| e | 9075 | |
| r | 8721 | |
| C | 6363 | |
| m | 5361 | |
| n | 4005 | 5.9% |
| s | 4005 | 5.9% |
| u | 4005 | 5.9% |
| f | 2712 | 4.0% |
| t | 2358 | 3.5% |
| Other values (7) | 11496 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 68178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 10077 | |
| e | 9075 | |
| r | 8721 | |
| C | 6363 | |
| m | 5361 | |
| n | 4005 | 5.9% |
| s | 4005 | 5.9% |
| u | 4005 | 5.9% |
| f | 2712 | 4.0% |
| t | 2358 | 3.5% |
| Other values (7) | 11496 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 68178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 10077 | |
| e | 9075 | |
| r | 8721 | |
| C | 6363 | |
| m | 5361 | |
| n | 4005 | 5.9% |
| s | 4005 | 5.9% |
| u | 4005 | 5.9% |
| f | 2712 | 4.0% |
| t | 2358 | 3.5% |
| Other values (7) | 11496 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 68178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 10077 | |
| e | 9075 | |
| r | 8721 | |
| C | 6363 | |
| m | 5361 | |
| n | 4005 | 5.9% |
| s | 4005 | 5.9% |
| u | 4005 | 5.9% |
| f | 2712 | 4.0% |
| t | 2358 | 3.5% |
| Other values (7) | 11496 |
City
Text
| Distinct | 1992 |
|---|---|
| Distinct (%) | 25.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 506.1 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 22 |
| Mean length | 8.4271279 |
| Min length | 3 |
Unique
| Unique | 785 ? |
|---|---|
| Unique (%) | 10.2% |
Sample
| 1st row | Oklahoma City |
|---|---|
| 2nd row | Oklahoma City |
| 3rd row | Seattle |
| 4th row | Seattle |
| 5th row | Arlington |
| Value | Count | Frequency (%) |
| city | 300 | 3.1% |
| san | 261 | 2.7% |
| los | 183 | 1.9% |
| york | 174 | 1.8% |
| new | 173 | 1.8% |
| angeles | 170 | 1.8% |
| francisco | 96 | 1.0% |
| philadelphia | 78 | 0.8% |
| de | 76 | 0.8% |
| manila | 73 | 0.8% |
| Other values (2111) | 8048 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 7911 | 12.2% |
| n | 5116 | 7.9% |
| e | 5085 | 7.8% |
| o | 4574 | 7.0% |
| i | 4019 | 6.2% |
| r | 3599 | 5.5% |
| l | 3218 | 4.9% |
| s | 2390 | 3.7% |
| t | 2387 | 3.7% |
| u | 2283 | 3.5% |
| Other values (61) | 24467 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65049 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 7911 | 12.2% |
| n | 5116 | 7.9% |
| e | 5085 | 7.8% |
| o | 4574 | 7.0% |
| i | 4019 | 6.2% |
| r | 3599 | 5.5% |
| l | 3218 | 4.9% |
| s | 2390 | 3.7% |
| t | 2387 | 3.7% |
| u | 2283 | 3.5% |
| Other values (61) | 24467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65049 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 7911 | 12.2% |
| n | 5116 | 7.9% |
| e | 5085 | 7.8% |
| o | 4574 | 7.0% |
| i | 4019 | 6.2% |
| r | 3599 | 5.5% |
| l | 3218 | 4.9% |
| s | 2390 | 3.7% |
| t | 2387 | 3.7% |
| u | 2283 | 3.5% |
| Other values (61) | 24467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65049 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 7911 | 12.2% |
| n | 5116 | 7.9% |
| e | 5085 | 7.8% |
| o | 4574 | 7.0% |
| i | 4019 | 6.2% |
| r | 3599 | 5.5% |
| l | 3218 | 4.9% |
| s | 2390 | 3.7% |
| t | 2387 | 3.7% |
| u | 2283 | 3.5% |
| Other values (61) | 24467 |
State
Text
| Distinct | 709 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 534.3 KiB |
Length
| Max length | 36 |
|---|---|
| Median length | 33 |
| Mean length | 10.38321 |
| Min length | 3 |
Unique
| Unique | 171 ? |
|---|---|
| Unique (%) | 2.2% |
Sample
| 1st row | Oklahoma |
|---|---|
| 2nd row | Oklahoma |
| 3rd row | Washington |
| 4th row | Washington |
| 5th row | Texas |
| Value | Count | Frequency (%) |
| california | 387 | 3.7% |
| new | 380 | 3.6% |
| england | 299 | 2.9% |
| south | 208 | 2.0% |
| ile-de-france | 205 | 2.0% |
| york | 198 | 1.9% |
| north | 174 | 1.7% |
| wales | 155 | 1.5% |
| queensland | 144 | 1.4% |
| rhine-westphalia | 136 | 1.3% |
| Other values (793) | 8142 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 11393 | 14.2% |
| n | 6468 | 8.1% |
| e | 5543 | 6.9% |
| i | 5479 | 6.8% |
| r | 4595 | 5.7% |
| o | 4384 | 5.5% |
| l | 3871 | 4.8% |
| t | 3350 | 4.2% |
| s | 3015 | 3.8% |
| 2709 | 3.4% | |
| Other values (66) | 29341 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80148 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 11393 | 14.2% |
| n | 6468 | 8.1% |
| e | 5543 | 6.9% |
| i | 5479 | 6.8% |
| r | 4595 | 5.7% |
| o | 4384 | 5.5% |
| l | 3871 | 4.8% |
| t | 3350 | 4.2% |
| s | 3015 | 3.8% |
| 2709 | 3.4% | |
| Other values (66) | 29341 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80148 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 11393 | 14.2% |
| n | 6468 | 8.1% |
| e | 5543 | 6.9% |
| i | 5479 | 6.8% |
| r | 4595 | 5.7% |
| o | 4384 | 5.5% |
| l | 3871 | 4.8% |
| t | 3350 | 4.2% |
| s | 3015 | 3.8% |
| 2709 | 3.4% | |
| Other values (66) | 29341 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80148 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 11393 | 14.2% |
| n | 6468 | 8.1% |
| e | 5543 | 6.9% |
| i | 5479 | 6.8% |
| r | 4595 | 5.7% |
| o | 4384 | 5.5% |
| l | 3871 | 4.8% |
| t | 3350 | 4.2% |
| s | 3015 | 3.8% |
| 2709 | 3.4% | |
| Other values (66) | 29341 |
Country
Text
| Distinct | 132 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 496.1 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 22 |
| Mean length | 8.7988081 |
| Min length | 4 |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
| Value | Count | Frequency (%) |
| united | 1857 | |
| states | 1531 | |
| france | 546 | 5.3% |
| australia | 530 | 5.1% |
| mexico | 427 | 4.1% |
| china | 424 | 4.1% |
| germany | 412 | 4.0% |
| kingdom | 326 | 3.2% |
| india | 320 | 3.1% |
| brazil | 234 | 2.3% |
| Other values (140) | 3690 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8487 | 12.5% |
| i | 6264 | 9.2% |
| e | 6175 | 9.1% |
| t | 6164 | 9.1% |
| n | 5834 | 8.6% |
| d | 3343 | 4.9% |
| r | 2808 | 4.1% |
| s | 2785 | 4.1% |
| 2578 | 3.8% | |
| o | 2101 | 3.1% |
| Other values (44) | 21379 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 67918 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 8487 | 12.5% |
| i | 6264 | 9.2% |
| e | 6175 | 9.1% |
| t | 6164 | 9.1% |
| n | 5834 | 8.6% |
| d | 3343 | 4.9% |
| r | 2808 | 4.1% |
| s | 2785 | 4.1% |
| 2578 | 3.8% | |
| o | 2101 | 3.1% |
| Other values (44) | 21379 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 67918 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 8487 | 12.5% |
| i | 6264 | 9.2% |
| e | 6175 | 9.1% |
| t | 6164 | 9.1% |
| n | 5834 | 8.6% |
| d | 3343 | 4.9% |
| r | 2808 | 4.1% |
| s | 2785 | 4.1% |
| 2578 | 3.8% | |
| o | 2101 | 3.1% |
| Other values (44) | 21379 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 67918 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 8487 | 12.5% |
| i | 6264 | 9.2% |
| e | 6175 | 9.1% |
| t | 6164 | 9.1% |
| n | 5834 | 8.6% |
| d | 3343 | 4.9% |
| r | 2808 | 4.1% |
| s | 2785 | 4.1% |
| 2578 | 3.8% | |
| o | 2101 | 3.1% |
| Other values (44) | 21379 |
Region
Categorical
High correlation 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 524.3 KiB |
| Western Europe | |
|---|---|
| Central America | |
| Oceania | |
| Western US | |
| Eastern Asia | |
| Other values (18) |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 12.536468 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Central US |
|---|---|
| 2nd row | Central US |
| 3rd row | Western US |
| 4th row | Western US |
| 5th row | Central US |
Common Values
| Value | Count | Frequency (%) |
| Western Europe | 1079 | |
| Central America | 816 | |
| Oceania | 632 | 8.2% |
| Western US | 542 | 7.0% |
| Eastern Asia | 499 | 6.5% |
| Southeastern Asia | 485 | 6.3% |
| Southern Asia | 459 | 5.9% |
| Eastern US | 457 | 5.9% |
| South America | 397 | 5.1% |
| Southern Europe | 356 | 4.6% |
| Other values (13) | 1997 |
Length
| Value | Count | Frequency (%) |
| europe | 2001 | |
| western | 1835 | |
| asia | 1584 | |
| us | 1531 | |
| eastern | 1250 | |
| central | 1226 | |
| america | 1213 | |
| southern | 1104 | |
| oceania | 632 | 4.4% |
| southeastern | 485 | 3.3% |
| Other values (6) | 1660 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 12653 | |
| r | 10679 | |
| a | 8116 | 8.4% |
| t | 7287 | 7.5% |
| n | 7170 | 7.4% |
| 6802 | 7.0% | |
| s | 5154 | 5.3% |
| o | 4492 | 4.6% |
| i | 4136 | 4.3% |
| u | 3987 | 4.1% |
| Other values (16) | 26293 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 96769 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 12653 | |
| r | 10679 | |
| a | 8116 | 8.4% |
| t | 7287 | 7.5% |
| n | 7170 | 7.4% |
| 6802 | 7.0% | |
| s | 5154 | 5.3% |
| o | 4492 | 4.6% |
| i | 4136 | 4.3% |
| u | 3987 | 4.1% |
| Other values (16) | 26293 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 96769 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 12653 | |
| r | 10679 | |
| a | 8116 | 8.4% |
| t | 7287 | 7.5% |
| n | 7170 | 7.4% |
| 6802 | 7.0% | |
| s | 5154 | 5.3% |
| o | 4492 | 4.6% |
| i | 4136 | 4.3% |
| u | 3987 | 4.1% |
| Other values (16) | 26293 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 96769 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 12653 | |
| r | 10679 | |
| a | 8116 | 8.4% |
| t | 7287 | 7.5% |
| n | 7170 | 7.4% |
| 6802 | 7.0% | |
| s | 5154 | 5.3% |
| o | 4492 | 4.6% |
| i | 4136 | 4.3% |
| u | 3987 | 4.1% |
| Other values (16) | 26293 |
Market
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 483.5 KiB |
| Asia Pacific | |
|---|---|
| Europe | |
| USCA | |
| LATAM | |
| Africa |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 7.1251457 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USCA |
|---|---|
| 2nd row | USCA |
| 3rd row | USCA |
| 4th row | USCA |
| 5th row | USCA |
Common Values
| Value | Count | Frequency (%) |
| Asia Pacific | 2216 | |
| Europe | 2001 | |
| USCA | 1582 | |
| LATAM | 1447 | |
| Africa | 473 | 6.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| asia | 2216 | |
| pacific | 2216 | |
| europe | 2001 | |
| usca | 1582 | |
| latam | 1447 | |
| africa | 473 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 7165 | |
| i | 7121 | |
| c | 4905 | 8.9% |
| a | 4905 | 8.9% |
| f | 2689 | 4.9% |
| r | 2474 | 4.5% |
| P | 2216 | 4.0% |
| 2216 | 4.0% | |
| s | 2216 | 4.0% |
| E | 2001 | 3.6% |
| Other values (10) | 17091 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 54999 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 7165 | |
| i | 7121 | |
| c | 4905 | 8.9% |
| a | 4905 | 8.9% |
| f | 2689 | 4.9% |
| r | 2474 | 4.5% |
| P | 2216 | 4.0% |
| 2216 | 4.0% | |
| s | 2216 | 4.0% |
| E | 2001 | 3.6% |
| Other values (10) | 17091 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 54999 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 7165 | |
| i | 7121 | |
| c | 4905 | 8.9% |
| a | 4905 | 8.9% |
| f | 2689 | 4.9% |
| r | 2474 | 4.5% |
| P | 2216 | 4.0% |
| 2216 | 4.0% | |
| s | 2216 | 4.0% |
| E | 2001 | 3.6% |
| Other values (10) | 17091 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 54999 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 7165 | |
| i | 7121 | |
| c | 4905 | 8.9% |
| a | 4905 | 8.9% |
| f | 2689 | 4.9% |
| r | 2474 | 4.5% |
| P | 2216 | 4.0% |
| 2216 | 4.0% | |
| s | 2216 | 4.0% |
| E | 2001 | 3.6% |
| Other values (10) | 17091 |
Product ID
Text
| Distinct | 2245 |
|---|---|
| Distinct (%) | 29.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 512.7 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 934 ? |
|---|---|
| Unique (%) | 12.1% |
Sample
| 1st row | TEC-PH-5816 |
|---|---|
| 2nd row | FUR-BO-5957 |
| 3rd row | FUR-CH-4421 |
| 4th row | OFF-AR-5309 |
| 5th row | OFF-ST-3078 |
| Value | Count | Frequency (%) |
| off-fa-6129 | 44 | 0.6% |
| off-st-4057 | 41 | 0.5% |
| fur-ch-5441 | 28 | 0.4% |
| off-st-6047 | 25 | 0.3% |
| off-st-6033 | 25 | 0.3% |
| off-st-5693 | 24 | 0.3% |
| off-st-4268 | 23 | 0.3% |
| off-st-4267 | 23 | 0.3% |
| off-st-6248 | 23 | 0.3% |
| fur-ch-4654 | 23 | 0.3% |
| Other values (2235) | 7440 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 15438 | |
| F | 7859 | 9.3% |
| C | 5193 | 6.1% |
| 5 | 5099 | 6.0% |
| 4 | 4468 | 5.3% |
| O | 4408 | 5.2% |
| 3 | 3972 | 4.7% |
| T | 3879 | 4.6% |
| 6 | 3313 | 3.9% |
| U | 2860 | 3.4% |
| Other values (17) | 28420 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 84909 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 15438 | |
| F | 7859 | 9.3% |
| C | 5193 | 6.1% |
| 5 | 5099 | 6.0% |
| 4 | 4468 | 5.3% |
| O | 4408 | 5.2% |
| 3 | 3972 | 4.7% |
| T | 3879 | 4.6% |
| 6 | 3313 | 3.9% |
| U | 2860 | 3.4% |
| Other values (17) | 28420 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 84909 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 15438 | |
| F | 7859 | 9.3% |
| C | 5193 | 6.1% |
| 5 | 5099 | 6.0% |
| 4 | 4468 | 5.3% |
| O | 4408 | 5.2% |
| 3 | 3972 | 4.7% |
| T | 3879 | 4.6% |
| 6 | 3313 | 3.9% |
| U | 2860 | 3.4% |
| Other values (17) | 28420 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 84909 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 15438 | |
| F | 7859 | 9.3% |
| C | 5193 | 6.1% |
| 5 | 5099 | 6.0% |
| 4 | 4468 | 5.3% |
| O | 4408 | 5.2% |
| 3 | 3972 | 4.7% |
| T | 3879 | 4.6% |
| 6 | 3313 | 3.9% |
| U | 2860 | 3.4% |
| Other values (17) | 28420 |
E-Commerce Site
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 485.6 KiB |
| Snapdeal | |
|---|---|
| Flipkart | |
| Amazon |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.4038088 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Snapdeal |
|---|---|
| 2nd row | Snapdeal |
| 3rd row | Snapdeal |
| 4th row | Flipkart |
| 5th row | Amazon |
Common Values
| Value | Count | Frequency (%) |
| Snapdeal | 2887 | |
| Flipkart | 2531 | |
| Amazon | 2301 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| snapdeal | 2887 | |
| flipkart | 2531 | |
| amazon | 2301 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 10606 | |
| p | 5418 | 9.5% |
| l | 5418 | 9.5% |
| n | 5188 | 9.1% |
| S | 2887 | 5.1% |
| d | 2887 | 5.1% |
| e | 2887 | 5.1% |
| F | 2531 | 4.4% |
| i | 2531 | 4.4% |
| k | 2531 | 4.4% |
| Other values (6) | 14266 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57150 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 10606 | |
| p | 5418 | 9.5% |
| l | 5418 | 9.5% |
| n | 5188 | 9.1% |
| S | 2887 | 5.1% |
| d | 2887 | 5.1% |
| e | 2887 | 5.1% |
| F | 2531 | 4.4% |
| i | 2531 | 4.4% |
| k | 2531 | 4.4% |
| Other values (6) | 14266 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57150 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 10606 | |
| p | 5418 | 9.5% |
| l | 5418 | 9.5% |
| n | 5188 | 9.1% |
| S | 2887 | 5.1% |
| d | 2887 | 5.1% |
| e | 2887 | 5.1% |
| F | 2531 | 4.4% |
| i | 2531 | 4.4% |
| k | 2531 | 4.4% |
| Other values (6) | 14266 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57150 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 10606 | |
| p | 5418 | 9.5% |
| l | 5418 | 9.5% |
| n | 5188 | 9.1% |
| S | 2887 | 5.1% |
| d | 2887 | 5.1% |
| e | 2887 | 5.1% |
| F | 2531 | 4.4% |
| i | 2531 | 4.4% |
| k | 2531 | 4.4% |
| Other values (6) | 14266 |
Category
Categorical
High correlation 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 515.0 KiB |
| Technology | |
|---|---|
| Office Supplies | |
| Furniture |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 11.307294 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Technology |
|---|---|
| 2nd row | Furniture |
| 3rd row | Furniture |
| 4th row | Office Supplies |
| 5th row | Office Supplies |
Common Values
| Value | Count | Frequency (%) |
| Technology | 2780 | |
| Office Supplies | 2505 | |
| Furniture | 2434 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| technology | 2780 | |
| office | 2505 | |
| supplies | 2505 | |
| furniture | 2434 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 10224 | 11.7% |
| i | 7444 | 8.5% |
| u | 7373 | 8.4% |
| o | 5560 | 6.4% |
| c | 5285 | 6.1% |
| l | 5285 | 6.1% |
| n | 5214 | 6.0% |
| f | 5010 | 5.7% |
| p | 5010 | 5.7% |
| r | 4868 | 5.6% |
| Other values (10) | 26008 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87281 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 10224 | 11.7% |
| i | 7444 | 8.5% |
| u | 7373 | 8.4% |
| o | 5560 | 6.4% |
| c | 5285 | 6.1% |
| l | 5285 | 6.1% |
| n | 5214 | 6.0% |
| f | 5010 | 5.7% |
| p | 5010 | 5.7% |
| r | 4868 | 5.6% |
| Other values (10) | 26008 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87281 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 10224 | 11.7% |
| i | 7444 | 8.5% |
| u | 7373 | 8.4% |
| o | 5560 | 6.4% |
| c | 5285 | 6.1% |
| l | 5285 | 6.1% |
| n | 5214 | 6.0% |
| f | 5010 | 5.7% |
| p | 5010 | 5.7% |
| r | 4868 | 5.6% |
| Other values (10) | 26008 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87281 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 10224 | 11.7% |
| i | 7444 | 8.5% |
| u | 7373 | 8.4% |
| o | 5560 | 6.4% |
| c | 5285 | 6.1% |
| l | 5285 | 6.1% |
| n | 5214 | 6.0% |
| f | 5010 | 5.7% |
| p | 5010 | 5.7% |
| r | 4868 | 5.6% |
| Other values (10) | 26008 |
Sub-Category
Categorical
High correlation 
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 486.2 KiB |
| Copiers | |
|---|---|
| Bookcases | |
| Chairs | |
| Storage | |
| Phones | |
| Other values (12) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 7.486462 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Phones |
|---|---|
| 2nd row | Bookcases |
| 3rd row | Chairs |
| 4th row | Art |
| 5th row | Storage |
Common Values
| Value | Count | Frequency (%) |
| Copiers | 953 | |
| Bookcases | 950 | |
| Chairs | 927 | |
| Storage | 876 | |
| Phones | 862 | |
| Accessories | 533 | |
| Appliances | 475 | |
| Machines | 432 | |
| Furnishings | 334 | 4.3% |
| Art | 302 | 3.9% |
| Other values (7) | 1075 |
Length
| Value | Count | Frequency (%) |
| copiers | 953 | |
| bookcases | 950 | |
| chairs | 927 | |
| storage | 876 | |
| phones | 862 | |
| accessories | 533 | |
| appliances | 475 | |
| machines | 432 | |
| furnishings | 334 | 4.3% |
| art | 302 | 3.9% |
| Other values (7) | 1075 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 8677 | |
| e | 6846 | |
| o | 5200 | 9.0% |
| r | 4543 | 7.9% |
| a | 4325 | 7.5% |
| i | 4322 | 7.5% |
| c | 2923 | 5.1% |
| n | 2836 | 4.9% |
| h | 2555 | 4.4% |
| p | 2458 | 4.3% |
| Other values (18) | 13103 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57788 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 8677 | |
| e | 6846 | |
| o | 5200 | 9.0% |
| r | 4543 | 7.9% |
| a | 4325 | 7.5% |
| i | 4322 | 7.5% |
| c | 2923 | 5.1% |
| n | 2836 | 4.9% |
| h | 2555 | 4.4% |
| p | 2458 | 4.3% |
| Other values (18) | 13103 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57788 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 8677 | |
| e | 6846 | |
| o | 5200 | 9.0% |
| r | 4543 | 7.9% |
| a | 4325 | 7.5% |
| i | 4322 | 7.5% |
| c | 2923 | 5.1% |
| n | 2836 | 4.9% |
| h | 2555 | 4.4% |
| p | 2458 | 4.3% |
| Other values (18) | 13103 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57788 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 8677 | |
| e | 6846 | |
| o | 5200 | 9.0% |
| r | 4543 | 7.9% |
| a | 4325 | 7.5% |
| i | 4322 | 7.5% |
| c | 2923 | 5.1% |
| n | 2836 | 4.9% |
| h | 2555 | 4.4% |
| p | 2458 | 4.3% |
| Other values (18) | 13103 |
Product Name
Text
| Distinct | 2245 |
|---|---|
| Distinct (%) | 29.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 661.9 KiB |
Length
| Max length | 109 |
|---|---|
| Median length | 88 |
| Mean length | 30.371551 |
| Min length | 5 |
Unique
| Unique | 934 ? |
|---|---|
| Unique (%) | 12.1% |
Sample
| 1st row | Samsung Convoy 3 |
|---|---|
| 2nd row | Sauder Facets Collection Library, Sky Alder Finish |
| 3rd row | Global Push Button Manager's Chair, Indigo |
| 4th row | Newell 330 |
| 5th row | Akro Stacking Bins |
| Value | Count | Frequency (%) |
| fax | 515 | 1.5% |
| with | 489 | 1.4% |
| machine | 442 | 1.3% |
| black | 437 | 1.3% |
| red | 387 | 1.1% |
| phone | 383 | 1.1% |
| chair | 369 | 1.1% |
| safco | 353 | 1.0% |
| lockers | 343 | 1.0% |
| set | 336 | 1.0% |
| Other values (1969) | 30324 |
Most occurring characters
| Value | Count | Frequency (%) |
| 26602 | 11.3% | |
| e | 22053 | 9.4% |
| a | 15132 | 6.5% |
| o | 14109 | 6.0% |
| r | 14054 | 6.0% |
| i | 13408 | 5.7% |
| l | 11028 | 4.7% |
| t | 9853 | 4.2% |
| n | 9115 | 3.9% |
| s | 7594 | 3.2% |
| Other values (72) | 91490 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 234438 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 26602 | 11.3% | |
| e | 22053 | 9.4% |
| a | 15132 | 6.5% |
| o | 14109 | 6.0% |
| r | 14054 | 6.0% |
| i | 13408 | 5.7% |
| l | 11028 | 4.7% |
| t | 9853 | 4.2% |
| n | 9115 | 3.9% |
| s | 7594 | 3.2% |
| Other values (72) | 91490 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 234438 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 26602 | 11.3% | |
| e | 22053 | 9.4% |
| a | 15132 | 6.5% |
| o | 14109 | 6.0% |
| r | 14054 | 6.0% |
| i | 13408 | 5.7% |
| l | 11028 | 4.7% |
| t | 9853 | 4.2% |
| n | 9115 | 3.9% |
| s | 7594 | 3.2% |
| Other values (72) | 91490 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 234438 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 26602 | 11.3% | |
| e | 22053 | 9.4% |
| a | 15132 | 6.5% |
| o | 14109 | 6.0% |
| r | 14054 | 6.0% |
| i | 13408 | 5.7% |
| l | 11028 | 4.7% |
| t | 9853 | 4.2% |
| n | 9115 | 3.9% |
| s | 7594 | 3.2% |
| Other values (72) | 91490 |
Sales
Real number (ℝ)
High correlation 
| Distinct | 6169 |
|---|---|
| Distinct (%) | 79.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 505.54721 |
| Minimum | 1.728 |
|---|---|
| Maximum | 1867.136 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | 1.728 |
|---|---|
| 5-th percentile | 17.336 |
| Q1 | 236.961 |
| median | 438.84 |
| Q3 | 713.20728 |
| 95-th percentile | 1236.465 |
| Maximum | 1867.136 |
| Range | 1865.408 |
| Interquartile range (IQR) | 476.24628 |
Descriptive statistics
| Standard deviation | 372.1854 |
|---|---|
| Coefficient of variation (CV) | 0.73620305 |
| Kurtosis | 0.793356 |
| Mean | 505.54721 |
| Median Absolute Deviation (MAD) | 231.72 |
| Skewness | 0.95055385 |
| Sum | 3902318.9 |
| Variance | 138521.97 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.552 | 12 | 0.2% |
| 17.94 | 7 | 0.1% |
| 394.98 | 7 | 0.1% |
| 14.94 | 6 | 0.1% |
| 272.76 | 6 | 0.1% |
| 366.84 | 6 | 0.1% |
| 10.368 | 6 | 0.1% |
| 12.96 | 6 | 0.1% |
| 19.44 | 5 | 0.1% |
| 333.96 | 5 | 0.1% |
| Other values (6159) | 7653 |
| Value | Count | Frequency (%) |
| 1.728 | 1 | |
| 1.744 | 1 | |
| 2.22 | 1 | |
| 2.304 | 1 | |
| 2.6 | 1 | |
| 2.632 | 1 | |
| 2.688 | 1 | |
| 2.89 | 1 | |
| 2.944 | 1 | |
| 2.97 | 1 |
| Value | Count | Frequency (%) |
| 1867.136 | 1 | |
| 1860 | 1 | |
| 1859.55 | 1 | |
| 1859.13 | 1 | |
| 1855.68 | 1 | |
| 1854.495 | 1 | |
| 1849.32 | 1 | |
| 1847.34 | 1 | |
| 1845.72 | 1 | |
| 1843.17 | 1 |
Quantity
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.0296671 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.1368146 |
|---|---|
| Coefficient of variation (CV) | 0.53027075 |
| Kurtosis | -0.2514218 |
| Mean | 4.0296671 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.70457992 |
| Sum | 31105 |
| Variance | 4.5659765 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 1631 | |
| 3 | 1582 | |
| 4 | 1172 | |
| 5 | 956 | |
| 6 | 629 | 8.1% |
| 1 | 566 | 7.3% |
| 7 | 544 | 7.0% |
| 8 | 337 | 4.4% |
| 9 | 235 | 3.0% |
| 10 | 67 | 0.9% |
| Value | Count | Frequency (%) |
| 1 | 566 | 7.3% |
| 2 | 1631 | |
| 3 | 1582 | |
| 4 | 1172 | |
| 5 | 956 | |
| 6 | 629 | 8.1% |
| 7 | 544 | 7.0% |
| 8 | 337 | 4.4% |
| 9 | 235 | 3.0% |
| 10 | 67 | 0.9% |
| Value | Count | Frequency (%) |
| 10 | 67 | 0.9% |
| 9 | 235 | 3.0% |
| 8 | 337 | 4.4% |
| 7 | 544 | 7.0% |
| 6 | 629 | 8.1% |
| 5 | 956 | |
| 4 | 1172 | |
| 3 | 1582 | |
| 2 | 1631 | |
| 1 | 566 | 7.3% |
Discount
Real number (ℝ)
Zeros 
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.072549035 |
| Minimum | 0 |
|---|---|
| Maximum | 0.402 |
| Zeros | 4504 |
| Zeros (%) | 58.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.1 |
| 95-th percentile | 0.35 |
| Maximum | 0.402 |
| Range | 0.402 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.10902344 |
|---|---|
| Coefficient of variation (CV) | 1.5027552 |
| Kurtosis | 1.4627052 |
| Mean | 0.072549035 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4896662 |
| Sum | 560.006 |
| Variance | 0.01188611 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4504 | |
| 0.1 | 1033 | 13.4% |
| 0.2 | 943 | 12.2% |
| 0.4 | 287 | 3.7% |
| 0.002 | 232 | 3.0% |
| 0.15 | 188 | 2.4% |
| 0.17 | 130 | 1.7% |
| 0.07 | 79 | 1.0% |
| 0.3 | 71 | 0.9% |
| 0.27 | 69 | 0.9% |
| Other values (6) | 183 | 2.4% |
| Value | Count | Frequency (%) |
| 0 | 4504 | |
| 0.002 | 232 | 3.0% |
| 0.07 | 79 | 1.0% |
| 0.1 | 1033 | 13.4% |
| 0.15 | 188 | 2.4% |
| 0.17 | 130 | 1.7% |
| 0.2 | 943 | 12.2% |
| 0.202 | 15 | 0.2% |
| 0.25 | 65 | 0.8% |
| 0.27 | 69 | 0.9% |
| Value | Count | Frequency (%) |
| 0.402 | 26 | 0.3% |
| 0.4 | 287 | 3.7% |
| 0.37 | 23 | 0.3% |
| 0.35 | 52 | 0.7% |
| 0.32 | 2 | < 0.1% |
| 0.3 | 71 | 0.9% |
| 0.27 | 69 | 0.9% |
| 0.25 | 65 | 0.8% |
| 0.202 | 15 | 0.2% |
| 0.2 | 943 |
Profit
Real number (ℝ)
Zeros 
| Distinct | 6138 |
|---|---|
| Distinct (%) | 79.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.874722 |
| Minimum | -254.34 |
|---|---|
| Maximum | 437.28 |
| Zeros | 101 |
| Zeros (%) | 1.3% |
| Negative | 1022 |
| Negative (%) | 13.2% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | -254.34 |
|---|---|
| 5-th percentile | -69.52098 |
| Q1 | 9.177 |
| median | 58.23576 |
| Q3 | 144.42 |
| 95-th percentile | 312.03958 |
| Maximum | 437.28 |
| Range | 691.62 |
| Interquartile range (IQR) | 135.243 |
Descriptive statistics
| Standard deviation | 114.62825 |
|---|---|
| Coefficient of variation (CV) | 1.3666602 |
| Kurtosis | 0.70938687 |
| Mean | 83.874722 |
| Median Absolute Deviation (MAD) | 54.95976 |
| Skewness | 0.61393802 |
| Sum | 647428.98 |
| Variance | 13139.635 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 101 | 1.3% |
| 5.4432 | 11 | 0.1% |
| 178.11 | 7 | 0.1% |
| 17.58 | 6 | 0.1% |
| 5.04 | 6 | 0.1% |
| 45.36 | 6 | 0.1% |
| 39.54 | 6 | 0.1% |
| 93.6 | 6 | 0.1% |
| 3.6288 | 6 | 0.1% |
| 43.2 | 6 | 0.1% |
| Other values (6128) | 7558 |
| Value | Count | Frequency (%) |
| -254.34 | 1 | |
| -252.9585 | 1 | |
| -251.74512 | 1 | |
| -250.82 | 1 | |
| -248.052 | 2 | |
| -244.944 | 1 | |
| -241.296 | 1 | |
| -241.2 | 1 | |
| -238.5525 | 1 | |
| -237.576 | 2 |
| Value | Count | Frequency (%) |
| 437.28 | 1 | < 0.1% |
| 436.94 | 1 | < 0.1% |
| 436.77 | 3 | |
| 435.888 | 1 | < 0.1% |
| 435.51 | 1 | < 0.1% |
| 434.4 | 2 | |
| 433.92 | 1 | < 0.1% |
| 433.44 | 1 | < 0.1% |
| 433.41 | 1 | < 0.1% |
| 433.26 | 1 | < 0.1% |
Shipping Cost
Real number (ℝ)
High correlation 
| Distinct | 5807 |
|---|---|
| Distinct (%) | 75.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.977191 |
| Minimum | 1.04 |
|---|---|
| Maximum | 195.59 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 60.4 KiB |
Quantile statistics
| Minimum | 1.04 |
|---|---|
| 5-th percentile | 1.8 |
| Q1 | 36.05 |
| median | 51.008 |
| Q3 | 78.1395 |
| 95-th percentile | 142.216 |
| Maximum | 195.59 |
| Range | 194.55 |
| Interquartile range (IQR) | 42.0895 |
Descriptive statistics
| Standard deviation | 40.540622 |
|---|---|
| Coefficient of variation (CV) | 0.68739493 |
| Kurtosis | 0.87469424 |
| Mean | 58.977191 |
| Median Absolute Deviation (MAD) | 17.835 |
| Skewness | 0.93630894 |
| Sum | 455244.94 |
| Variance | 1643.542 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.33 | 11 | 0.1% |
| 1.26 | 10 | 0.1% |
| 1.27 | 10 | 0.1% |
| 1.2 | 9 | 0.1% |
| 1.71 | 9 | 0.1% |
| 1.49 | 9 | 0.1% |
| 1.31 | 9 | 0.1% |
| 1.23 | 9 | 0.1% |
| 1.41 | 9 | 0.1% |
| 1.18 | 8 | 0.1% |
| Other values (5797) | 7626 |
| Value | Count | Frequency (%) |
| 1.04 | 1 | < 0.1% |
| 1.06 | 2 | < 0.1% |
| 1.07 | 6 | |
| 1.08 | 1 | < 0.1% |
| 1.09 | 4 | |
| 1.1 | 3 | |
| 1.11 | 5 | |
| 1.12 | 3 | |
| 1.13 | 4 | |
| 1.14 | 5 |
| Value | Count | Frequency (%) |
| 195.59 | 1 | |
| 195.533 | 1 | |
| 195.371 | 1 | |
| 195.25 | 1 | |
| 195.24 | 1 | |
| 195.23 | 1 | |
| 194.97 | 1 | |
| 194.67 | 1 | |
| 194.6 | 1 | |
| 194.42 | 1 |
Order Priority
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 469.9 KiB |
| Medium | |
|---|---|
| High | |
| Critical | |
| Low |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 5.3135121 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | High |
|---|---|
| 2nd row | High |
| 3rd row | High |
| 4th row | High |
| 5th row | Low |
Common Values
| Value | Count | Frequency (%) |
| Medium | 3423 | |
| High | 2894 | |
| Critical | 939 | 12.2% |
| Low | 463 | 6.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| medium | 3423 | |
| high | 2894 | |
| critical | 939 | 12.2% |
| low | 463 | 6.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 8195 | |
| M | 3423 | |
| d | 3423 | |
| u | 3423 | |
| m | 3423 | |
| e | 3423 | |
| H | 2894 | 7.1% |
| g | 2894 | 7.1% |
| h | 2894 | 7.1% |
| c | 939 | 2.3% |
| Other values (8) | 6084 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 41015 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 8195 | |
| M | 3423 | |
| d | 3423 | |
| u | 3423 | |
| m | 3423 | |
| e | 3423 | |
| H | 2894 | 7.1% |
| g | 2894 | 7.1% |
| h | 2894 | 7.1% |
| c | 939 | 2.3% |
| Other values (8) | 6084 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 41015 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 8195 | |
| M | 3423 | |
| d | 3423 | |
| u | 3423 | |
| m | 3423 | |
| e | 3423 | |
| H | 2894 | 7.1% |
| g | 2894 | 7.1% |
| h | 2894 | 7.1% |
| c | 939 | 2.3% |
| Other values (8) | 6084 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 41015 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 8195 | |
| M | 3423 | |
| d | 3423 | |
| u | 3423 | |
| m | 3423 | |
| e | 3423 | |
| H | 2894 | 7.1% |
| g | 2894 | 7.1% |
| h | 2894 | 7.1% |
| c | 939 | 2.3% |
| Other values (8) | 6084 |
Interactions
Correlations
| Category | Discount | E-Commerce Site | Market | Order Priority | Profit | Quantity | Region | Row ID | Sales | Segment | Ship Mode | Shipping Cost | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | 1.000 | 0.236 | 0.000 | 0.243 | 0.043 | 0.181 | 0.055 | 0.244 | 0.085 | 0.280 | 0.022 | 0.031 | 0.255 | 0.999 |
| Discount | 0.236 | 1.000 | 0.000 | 0.336 | 0.044 | -0.397 | 0.022 | 0.395 | -0.020 | -0.025 | 0.012 | 0.035 | -0.044 | 0.214 |
| E-Commerce Site | 0.000 | 0.000 | 1.000 | 0.020 | 0.000 | 0.024 | 0.000 | 0.000 | 0.024 | 0.000 | 0.004 | 0.000 | 0.024 | 0.000 |
| Market | 0.243 | 0.336 | 0.020 | 1.000 | 0.081 | 0.249 | 0.161 | 0.999 | 0.153 | 0.350 | 0.011 | 0.066 | 0.433 | 0.293 |
| Order Priority | 0.043 | 0.044 | 0.000 | 0.081 | 1.000 | 0.102 | 0.040 | 0.089 | 0.084 | 0.192 | 0.020 | 0.296 | 0.122 | 0.076 |
| Profit | 0.181 | -0.397 | 0.024 | 0.249 | 0.102 | 1.000 | 0.129 | 0.181 | -0.112 | 0.489 | 0.000 | 0.077 | 0.387 | 0.141 |
| Quantity | 0.055 | 0.022 | 0.000 | 0.161 | 0.040 | 0.129 | 1.000 | 0.144 | -0.068 | 0.248 | 0.000 | 0.038 | 0.182 | 0.082 |
| Region | 0.244 | 0.395 | 0.000 | 0.999 | 0.089 | 0.181 | 0.144 | 1.000 | 0.108 | 0.235 | 0.025 | 0.078 | 0.289 | 0.153 |
| Row ID | 0.085 | -0.020 | 0.024 | 0.153 | 0.084 | -0.112 | -0.068 | 0.108 | 1.000 | -0.284 | 0.030 | 0.073 | -0.568 | 0.073 |
| Sales | 0.280 | -0.025 | 0.000 | 0.350 | 0.192 | 0.489 | 0.248 | 0.235 | -0.284 | 1.000 | 0.000 | 0.159 | 0.727 | 0.223 |
| Segment | 0.022 | 0.012 | 0.004 | 0.011 | 0.020 | 0.000 | 0.000 | 0.025 | 0.030 | 0.000 | 1.000 | 0.011 | 0.020 | 0.019 |
| Ship Mode | 0.031 | 0.035 | 0.000 | 0.066 | 0.296 | 0.077 | 0.038 | 0.078 | 0.073 | 0.159 | 0.011 | 1.000 | 0.098 | 0.065 |
| Shipping Cost | 0.255 | -0.044 | 0.024 | 0.433 | 0.122 | 0.387 | 0.182 | 0.289 | -0.568 | 0.727 | 0.020 | 0.098 | 1.000 | 0.204 |
| Sub-Category | 0.999 | 0.214 | 0.000 | 0.293 | 0.076 | 0.141 | 0.082 | 0.153 | 0.073 | 0.223 | 0.019 | 0.065 | 0.204 | 1.000 |
Missing values
Sample
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | City | State | Country | Region | Market | Product ID | E-Commerce Site | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Shipping Cost | Order Priority | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | CA-2014-AB10015140-41954 | 2014-11-11 | 2014-11-13 | First Class | AB-100151402 | Aaron Bergman | Consumer | Oklahoma City | Oklahoma | United States | Central US | USCA | TEC-PH-5816 | Snapdeal | Technology | Phones | Samsung Convoy 3 | 221.980 | 2 | 0.0 | 62.1544 | 40.77 | High |
| 1 | 9 | CA-2014-AB10015140-41954 | 2014-11-11 | 2014-11-13 | First Class | AB-100151402 | Aaron Bergman | Consumer | Oklahoma City | Oklahoma | United States | Central US | USCA | FUR-BO-5957 | Snapdeal | Furniture | Bookcases | Sauder Facets Collection Library, Sky Alder Finish | 341.960 | 2 | 0.0 | 54.7136 | 25.27 | High |
| 2 | 10 | CA-2012-AB10015140-40974 | 2012-03-06 | 2012-03-07 | First Class | AB-100151404 | Aaron Bergman | Consumer | Seattle | Washington | United States | Western US | USCA | FUR-CH-4421 | Snapdeal | Furniture | Chairs | Global Push Button Manager's Chair, Indigo | 48.712 | 1 | 0.2 | 5.4801 | 11.13 | High |
| 3 | 11 | CA-2012-AB10015140-40974 | 2012-03-06 | 2012-03-07 | First Class | AB-100151404 | Aaron Bergman | Consumer | Seattle | Washington | United States | Western US | USCA | OFF-AR-5309 | Flipkart | Office Supplies | Art | Newell 330 | 17.940 | 3 | 0.0 | 4.6644 | 4.29 | High |
| 4 | 17 | CA-2012-AB10015140-40958 | 2012-02-19 | 2012-02-25 | Standard Class | AB-100151402 | Aaron Bergman | Consumer | Arlington | Texas | United States | Central US | USCA | OFF-ST-3078 | Amazon | Office Supplies | Storage | Akro Stacking Bins | 12.624 | 2 | 0.2 | -2.5248 | 1.97 | Low |
| 5 | 22 | CA-2012-AB10015140-40974 | 2012-03-06 | 2012-03-07 | First Class | AB-100151404 | Aaron Bergman | Consumer | Seattle | Washington | United States | Western US | USCA | OFF-ST-3744 | Amazon | Office Supplies | Storage | Carina 42"Hx23 3/4"W Media Storage Unit | 242.940 | 3 | 0.0 | 4.8588 | 1.28 | High |
| 6 | 29 | CA-2012-AH10030140-41020 | 2012-04-21 | 2012-04-23 | Second Class | AH-100301406 | Aaron Hawkins | Corporate | Troy | New York | United States | Eastern US | USCA | OFF-FA-6129 | Flipkart | Office Supplies | Fasteners | Staples | 247.840 | 8 | 0.0 | 121.4416 | 55.20 | Critical |
| 7 | 33 | CA-2013-AH10030140-41635 | 2013-12-27 | 2013-12-31 | Standard Class | AH-100301404 | Aaron Hawkins | Corporate | San Francisco | California | United States | Western US | USCA | TEC-PH-4389 | Amazon | Technology | Phones | Geemarc AmpliPOWER60 | 668.160 | 9 | 0.2 | 75.1680 | 45.74 | Medium |
| 8 | 35 | CA-2013-AH10030140-41635 | 2013-12-27 | 2013-12-31 | Standard Class | AH-100301404 | Aaron Hawkins | Corporate | San Francisco | California | United States | Western US | USCA | OFF-ST-4291 | Flipkart | Office Supplies | Storage | Fellowes Super Stor/Drawer Files | 323.100 | 2 | 0.0 | 61.3890 | 26.70 | Medium |
| 9 | 37 | CA-2012-AH10030140-41041 | 2012-05-12 | 2012-05-18 | Standard Class | AH-100301404 | Aaron Hawkins | Corporate | Los Angeles | California | United States | Western US | USCA | FUR-CH-4840 | Amazon | Furniture | Chairs | Iceberg Nesting Folding Chair, 19w x 6d x 43h | 279.456 | 6 | 0.2 | 20.9592 | 11.69 | Medium |
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | City | State | Country | Region | Market | Product ID | E-Commerce Site | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | Shipping Cost | Order Priority | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7709 | 9989 | IN-2015-JS158807-42180 | 2015-06-25 | 2015-06-30 | Standard Class | JS-158807 | John Stevenson | Consumer | Brisbane | Queensland | Australia | Oceania | Asia Pacific | OFF-ST-5702 | Snapdeal | Office Supplies | Storage | Rogers Lockers, Single Width | 571.455 | 3 | 0.1 | 215.865 | 32.950 | Medium |
| 7710 | 9990 | IN-2012-VP217307-41166 | 2012-09-14 | 2012-09-17 | Second Class | VP-217307 | Victor Preis | Home Office | Brisbane | Queensland | Australia | Oceania | Asia Pacific | TEC-AC-4155 | Snapdeal | Technology | Accessories | Enermax Keyboard, Bluetooth | 75.114 | 1 | 0.1 | -5.856 | 32.940 | Critical |
| 7711 | 9991 | MX-2013-JF1519026-41305 | 2013-01-31 | 2013-02-05 | Standard Class | JF-1519026 | Jamie Frazer | Consumer | Santiago | Santiago | Chile | South America | LATAM | TEC-PH-5339 | Amazon | Technology | Phones | Nokia Headset, Cordless | 151.920 | 3 | 0.0 | 71.400 | 32.938 | High |
| 7712 | 9992 | CA-2012-CK12205140-41075 | 2012-06-15 | 2012-06-20 | Standard Class | CK-122051406 | Chloris Kastensmidt | Consumer | Hempstead | New York | United States | Eastern US | USCA | OFF-AR-3517 | Flipkart | Office Supplies | Art | Boston 16750 Black Compact Battery Pencil Sharpener | 35.000 | 4 | 0.0 | 10.500 | 1.720 | Medium |
| 7713 | 9994 | ES-2014-HA1490564-41863 | 2014-08-12 | 2014-08-16 | Standard Class | HA-1490564 | Helen Abelman | Consumer | Genoa | Liguria | Italy | Southern Europe | Europe | FUR-BO-5768 | Flipkart | Furniture | Bookcases | Safco Corner Shelving, Metal | 297.840 | 2 | 0.0 | 74.460 | 32.920 | Medium |
| 7714 | 9995 | MX-2012-MS1777036-41193 | 2012-10-11 | 2012-10-16 | Standard Class | MS-1777036 | Maxwell Schwartz | Consumer | Santo Domingo | Santo Domingo | Dominican Republic | Caribbean | LATAM | OFF-AP-3584 | Amazon | Office Supplies | Appliances | Breville Toaster, Silver | 206.560 | 5 | 0.2 | 48.960 | 32.902 | High |
| 7715 | 9996 | IN-2015-AS1013558-42229 | 2015-08-13 | 2015-08-18 | Standard Class | AS-1013558 | Adrian Shami | Home Office | Bilaspur | Uttar Pradesh | India | Southern Asia | Asia Pacific | TEC-AC-4165 | Amazon | Technology | Accessories | Enermax Memory Card, Programmable | 579.450 | 5 | 0.0 | 225.900 | 32.900 | Medium |
| 7716 | 9997 | RS-2015-NH8610108-42364 | 2015-12-26 | 2015-12-28 | Second Class | NH-8610108 | Nicole Hansen | Corporate | Yaroslavl' | Yaroslavl' | Russia | Eastern Europe | Europe | TEC-CO-4576 | Amazon | Technology | Copiers | Hewlett Fax Machine, Digital | 319.560 | 1 | 0.0 | 146.970 | 32.900 | Medium |
| 7717 | 9998 | IN-2012-CA1277558-41214 | 2012-11-01 | 2012-11-06 | Standard Class | CA-1277558 | Cynthia Arntzen | Consumer | Satna | Madhya Pradesh | India | Southern Asia | Asia Pacific | TEC-CO-5994 | Amazon | Technology | Copiers | Sharp Fax and Copier, Digital | 504.720 | 3 | 0.0 | 232.110 | 32.890 | Medium |
| 7718 | 9999 | ES-2013-MC1813045-41597 | 2013-11-19 | 2013-11-24 | Standard Class | MC-1813045 | Mike Caudle | Corporate | Argenteuil | Ile-de-France | France | Western Europe | Europe | OFF-AR-3555 | Snapdeal | Office Supplies | Art | Boston Sketch Pad, Water Color | 414.240 | 8 | 0.0 | 12.240 | 32.890 | Medium |